﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AdventureWorksDW2012DataSet" targetNamespace="http://tempuri.org/AdventureWorksDW2012DataSet.xsd" xmlns:mstns="http://tempuri.org/AdventureWorksDW2012DataSet.xsd" xmlns="http://tempuri.org/AdventureWorksDW2012DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AdventureWorksDW2012ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AdventureWorksDW2012ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DaxStudio.UI.Experiments.Properties.Settings.GlobalReference.Default.AdventureWorksDW2012ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DimResellerTableAdapter" GeneratorDataComponentClassName="DimResellerTableAdapter" Name="DimReseller" UserDataComponentName="DimResellerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksDW2012ConnectionString (Settings)" DbObjectName="AdventureWorksDW2012.dbo.DimReseller" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DimReseller] WHERE (([ResellerKey] = @Original_ResellerKey) AND ((@IsNull_GeographyKey = 1 AND [GeographyKey] IS NULL) OR ([GeographyKey] = @Original_GeographyKey)) AND ((@IsNull_ResellerAlternateKey = 1 AND [ResellerAlternateKey] IS NULL) OR ([ResellerAlternateKey] = @Original_ResellerAlternateKey)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ([BusinessType] = @Original_BusinessType) AND ([ResellerName] = @Original_ResellerName) AND ((@IsNull_NumberEmployees = 1 AND [NumberEmployees] IS NULL) OR ([NumberEmployees] = @Original_NumberEmployees)) AND ((@IsNull_OrderFrequency = 1 AND [OrderFrequency] IS NULL) OR ([OrderFrequency] = @Original_OrderFrequency)) AND ((@IsNull_OrderMonth = 1 AND [OrderMonth] IS NULL) OR ([OrderMonth] = @Original_OrderMonth)) AND ((@IsNull_FirstOrderYear = 1 AND [FirstOrderYear] IS NULL) OR ([FirstOrderYear] = @Original_FirstOrderYear)) AND ((@IsNull_LastOrderYear = 1 AND [LastOrderYear] IS NULL) OR ([LastOrderYear] = @Original_LastOrderYear)) AND ((@IsNull_ProductLine = 1 AND [ProductLine] IS NULL) OR ([ProductLine] = @Original_ProductLine)) AND ((@IsNull_AddressLine1 = 1 AND [AddressLine1] IS NULL) OR ([AddressLine1] = @Original_AddressLine1)) AND ((@IsNull_AddressLine2 = 1 AND [AddressLine2] IS NULL) OR ([AddressLine2] = @Original_AddressLine2)) AND ((@IsNull_AnnualSales = 1 AND [AnnualSales] IS NULL) OR ([AnnualSales] = @Original_AnnualSales)) AND ((@IsNull_BankName = 1 AND [BankName] IS NULL) OR ([BankName] = @Original_BankName)) AND ((@IsNull_MinPaymentType = 1 AND [MinPaymentType] IS NULL) OR ([MinPaymentType] = @Original_MinPaymentType)) AND ((@IsNull_MinPaymentAmount = 1 AND [MinPaymentAmount] IS NULL) OR ([MinPaymentAmount] = @Original_MinPaymentAmount)) AND ((@IsNull_AnnualRevenue = 1 AND [AnnualRevenue] IS NULL) OR ([AnnualRevenue] = @Original_AnnualRevenue)) AND ((@IsNull_YearOpened = 1 AND [YearOpened] IS NULL) OR ([YearOpened] = @Original_YearOpened)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ResellerKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResellerKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GeographyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GeographyKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GeographyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GeographyKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResellerAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResellerAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ResellerAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BusinessType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BusinessType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ResellerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberEmployees" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberEmployees" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderFrequency" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderFrequency" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_OrderFrequency" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OrderFrequency" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderMonth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderMonth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_OrderMonth" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="OrderMonth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FirstOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstOrderYear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FirstOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstOrderYear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastOrderYear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LastOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastOrderYear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductLine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AddressLine1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AddressLine1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AddressLine2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AddressLine2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnualSales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnualSales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AnnualSales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualSales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinPaymentType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinPaymentType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_MinPaymentType" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="MinPaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinPaymentAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinPaymentAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_MinPaymentAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinPaymentAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnualRevenue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnualRevenue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AnnualRevenue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualRevenue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YearOpened" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOpened" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_YearOpened" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOpened" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DimReseller] ([GeographyKey], [ResellerAlternateKey], [Phone], [BusinessType], [ResellerName], [NumberEmployees], [OrderFrequency], [OrderMonth], [FirstOrderYear], [LastOrderYear], [ProductLine], [AddressLine1], [AddressLine2], [AnnualSales], [BankName], [MinPaymentType], [MinPaymentAmount], [AnnualRevenue], [YearOpened]) VALUES (@GeographyKey, @ResellerAlternateKey, @Phone, @BusinessType, @ResellerName, @NumberEmployees, @OrderFrequency, @OrderMonth, @FirstOrderYear, @LastOrderYear, @ProductLine, @AddressLine1, @AddressLine2, @AnnualSales, @BankName, @MinPaymentType, @MinPaymentAmount, @AnnualRevenue, @YearOpened);
SELECT ResellerKey, GeographyKey, ResellerAlternateKey, Phone, BusinessType, ResellerName, NumberEmployees, OrderFrequency, OrderMonth, FirstOrderYear, LastOrderYear, ProductLine, AddressLine1, AddressLine2, AnnualSales, BankName, MinPaymentType, MinPaymentAmount, AnnualRevenue, YearOpened FROM DimReseller WHERE (ResellerKey = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GeographyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GeographyKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResellerAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BusinessType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BusinessType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResellerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberEmployees" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@OrderFrequency" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OrderFrequency" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@OrderMonth" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="OrderMonth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FirstOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstOrderYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LastOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastOrderYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductLine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddressLine1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddressLine2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AnnualSales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualSales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@MinPaymentType" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="MinPaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MinPaymentAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinPaymentAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AnnualRevenue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualRevenue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@YearOpened" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOpened" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ResellerKey, GeographyKey, ResellerAlternateKey, Phone, BusinessType, ResellerName, NumberEmployees, OrderFrequency, OrderMonth, FirstOrderYear, LastOrderYear, ProductLine, AddressLine1, AddressLine2, AnnualSales, BankName, MinPaymentType, MinPaymentAmount, AnnualRevenue, YearOpened FROM dbo.DimReseller</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DimReseller] SET [GeographyKey] = @GeographyKey, [ResellerAlternateKey] = @ResellerAlternateKey, [Phone] = @Phone, [BusinessType] = @BusinessType, [ResellerName] = @ResellerName, [NumberEmployees] = @NumberEmployees, [OrderFrequency] = @OrderFrequency, [OrderMonth] = @OrderMonth, [FirstOrderYear] = @FirstOrderYear, [LastOrderYear] = @LastOrderYear, [ProductLine] = @ProductLine, [AddressLine1] = @AddressLine1, [AddressLine2] = @AddressLine2, [AnnualSales] = @AnnualSales, [BankName] = @BankName, [MinPaymentType] = @MinPaymentType, [MinPaymentAmount] = @MinPaymentAmount, [AnnualRevenue] = @AnnualRevenue, [YearOpened] = @YearOpened WHERE (([ResellerKey] = @Original_ResellerKey) AND ((@IsNull_GeographyKey = 1 AND [GeographyKey] IS NULL) OR ([GeographyKey] = @Original_GeographyKey)) AND ((@IsNull_ResellerAlternateKey = 1 AND [ResellerAlternateKey] IS NULL) OR ([ResellerAlternateKey] = @Original_ResellerAlternateKey)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ([BusinessType] = @Original_BusinessType) AND ([ResellerName] = @Original_ResellerName) AND ((@IsNull_NumberEmployees = 1 AND [NumberEmployees] IS NULL) OR ([NumberEmployees] = @Original_NumberEmployees)) AND ((@IsNull_OrderFrequency = 1 AND [OrderFrequency] IS NULL) OR ([OrderFrequency] = @Original_OrderFrequency)) AND ((@IsNull_OrderMonth = 1 AND [OrderMonth] IS NULL) OR ([OrderMonth] = @Original_OrderMonth)) AND ((@IsNull_FirstOrderYear = 1 AND [FirstOrderYear] IS NULL) OR ([FirstOrderYear] = @Original_FirstOrderYear)) AND ((@IsNull_LastOrderYear = 1 AND [LastOrderYear] IS NULL) OR ([LastOrderYear] = @Original_LastOrderYear)) AND ((@IsNull_ProductLine = 1 AND [ProductLine] IS NULL) OR ([ProductLine] = @Original_ProductLine)) AND ((@IsNull_AddressLine1 = 1 AND [AddressLine1] IS NULL) OR ([AddressLine1] = @Original_AddressLine1)) AND ((@IsNull_AddressLine2 = 1 AND [AddressLine2] IS NULL) OR ([AddressLine2] = @Original_AddressLine2)) AND ((@IsNull_AnnualSales = 1 AND [AnnualSales] IS NULL) OR ([AnnualSales] = @Original_AnnualSales)) AND ((@IsNull_BankName = 1 AND [BankName] IS NULL) OR ([BankName] = @Original_BankName)) AND ((@IsNull_MinPaymentType = 1 AND [MinPaymentType] IS NULL) OR ([MinPaymentType] = @Original_MinPaymentType)) AND ((@IsNull_MinPaymentAmount = 1 AND [MinPaymentAmount] IS NULL) OR ([MinPaymentAmount] = @Original_MinPaymentAmount)) AND ((@IsNull_AnnualRevenue = 1 AND [AnnualRevenue] IS NULL) OR ([AnnualRevenue] = @Original_AnnualRevenue)) AND ((@IsNull_YearOpened = 1 AND [YearOpened] IS NULL) OR ([YearOpened] = @Original_YearOpened)));
SELECT ResellerKey, GeographyKey, ResellerAlternateKey, Phone, BusinessType, ResellerName, NumberEmployees, OrderFrequency, OrderMonth, FirstOrderYear, LastOrderYear, ProductLine, AddressLine1, AddressLine2, AnnualSales, BankName, MinPaymentType, MinPaymentAmount, AnnualRevenue, YearOpened FROM DimReseller WHERE (ResellerKey = @ResellerKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GeographyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GeographyKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResellerAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerAlternateKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BusinessType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BusinessType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResellerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberEmployees" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@OrderFrequency" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OrderFrequency" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@OrderMonth" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="OrderMonth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FirstOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstOrderYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LastOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastOrderYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductLine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddressLine1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddressLine2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AnnualSales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualSales" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@MinPaymentType" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="MinPaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MinPaymentAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinPaymentAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AnnualRevenue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualRevenue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@YearOpened" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOpened" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ResellerKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResellerKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GeographyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GeographyKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GeographyKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GeographyKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResellerAlternateKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResellerAlternateKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ResellerAlternateKey" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerAlternateKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BusinessType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BusinessType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ResellerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResellerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberEmployees" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberEmployees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberEmployees" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderFrequency" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderFrequency" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_OrderFrequency" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OrderFrequency" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderMonth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderMonth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_OrderMonth" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="OrderMonth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FirstOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstOrderYear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FirstOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstOrderYear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastOrderYear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LastOrderYear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastOrderYear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductLine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductLine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AddressLine1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AddressLine1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AddressLine2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AddressLine2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnualSales" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnualSales" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AnnualSales" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualSales" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinPaymentType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinPaymentType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_MinPaymentType" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="MinPaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinPaymentAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinPaymentAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_MinPaymentAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinPaymentAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AnnualRevenue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnualRevenue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AnnualRevenue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AnnualRevenue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YearOpened" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOpened" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_YearOpened" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOpened" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ResellerKey" ColumnName="ResellerKey" DataSourceName="AdventureWorksDW2012.dbo.DimReseller" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ResellerKey" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ResellerKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ResellerKey" DataSetColumn="ResellerKey" />
              <Mapping SourceColumn="GeographyKey" DataSetColumn="GeographyKey" />
              <Mapping SourceColumn="ResellerAlternateKey" DataSetColumn="ResellerAlternateKey" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="BusinessType" DataSetColumn="BusinessType" />
              <Mapping SourceColumn="ResellerName" DataSetColumn="ResellerName" />
              <Mapping SourceColumn="NumberEmployees" DataSetColumn="NumberEmployees" />
              <Mapping SourceColumn="OrderFrequency" DataSetColumn="OrderFrequency" />
              <Mapping SourceColumn="OrderMonth" DataSetColumn="OrderMonth" />
              <Mapping SourceColumn="FirstOrderYear" DataSetColumn="FirstOrderYear" />
              <Mapping SourceColumn="LastOrderYear" DataSetColumn="LastOrderYear" />
              <Mapping SourceColumn="ProductLine" DataSetColumn="ProductLine" />
              <Mapping SourceColumn="AddressLine1" DataSetColumn="AddressLine1" />
              <Mapping SourceColumn="AddressLine2" DataSetColumn="AddressLine2" />
              <Mapping SourceColumn="AnnualSales" DataSetColumn="AnnualSales" />
              <Mapping SourceColumn="BankName" DataSetColumn="BankName" />
              <Mapping SourceColumn="MinPaymentType" DataSetColumn="MinPaymentType" />
              <Mapping SourceColumn="MinPaymentAmount" DataSetColumn="MinPaymentAmount" />
              <Mapping SourceColumn="AnnualRevenue" DataSetColumn="AnnualRevenue" />
              <Mapping SourceColumn="YearOpened" DataSetColumn="YearOpened" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AdventureWorksDW2012DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="AdventureWorksDW2012DataSet" msprop:Generator_UserDSName="AdventureWorksDW2012DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DimReseller" msprop:Generator_TableClassName="DimResellerDataTable" msprop:Generator_TableVarName="tableDimReseller" msprop:Generator_TablePropName="DimReseller" msprop:Generator_RowDeletingName="DimResellerRowDeleting" msprop:Generator_RowChangingName="DimResellerRowChanging" msprop:Generator_RowEvHandlerName="DimResellerRowChangeEventHandler" msprop:Generator_RowDeletedName="DimResellerRowDeleted" msprop:Generator_UserTableName="DimReseller" msprop:Generator_RowChangedName="DimResellerRowChanged" msprop:Generator_RowEvArgName="DimResellerRowChangeEvent" msprop:Generator_RowClassName="DimResellerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ResellerKey" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnResellerKey" msprop:Generator_ColumnPropNameInRow="ResellerKey" msprop:Generator_ColumnPropNameInTable="ResellerKeyColumn" msprop:Generator_UserColumnName="ResellerKey" type="xs:int" />
              <xs:element name="GeographyKey" msprop:Generator_ColumnVarNameInTable="columnGeographyKey" msprop:Generator_ColumnPropNameInRow="GeographyKey" msprop:Generator_ColumnPropNameInTable="GeographyKeyColumn" msprop:Generator_UserColumnName="GeographyKey" type="xs:int" minOccurs="0" />
              <xs:element name="ResellerAlternateKey" msprop:Generator_ColumnVarNameInTable="columnResellerAlternateKey" msprop:Generator_ColumnPropNameInRow="ResellerAlternateKey" msprop:Generator_ColumnPropNameInTable="ResellerAlternateKeyColumn" msprop:Generator_UserColumnName="ResellerAlternateKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BusinessType" msprop:Generator_ColumnVarNameInTable="columnBusinessType" msprop:Generator_ColumnPropNameInRow="BusinessType" msprop:Generator_ColumnPropNameInTable="BusinessTypeColumn" msprop:Generator_UserColumnName="BusinessType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResellerName" msprop:Generator_ColumnVarNameInTable="columnResellerName" msprop:Generator_ColumnPropNameInRow="ResellerName" msprop:Generator_ColumnPropNameInTable="ResellerNameColumn" msprop:Generator_UserColumnName="ResellerName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumberEmployees" msprop:Generator_ColumnVarNameInTable="columnNumberEmployees" msprop:Generator_ColumnPropNameInRow="NumberEmployees" msprop:Generator_ColumnPropNameInTable="NumberEmployeesColumn" msprop:Generator_UserColumnName="NumberEmployees" type="xs:int" minOccurs="0" />
              <xs:element name="OrderFrequency" msprop:Generator_ColumnVarNameInTable="columnOrderFrequency" msprop:Generator_ColumnPropNameInRow="OrderFrequency" msprop:Generator_ColumnPropNameInTable="OrderFrequencyColumn" msprop:Generator_UserColumnName="OrderFrequency" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderMonth" msprop:Generator_ColumnVarNameInTable="columnOrderMonth" msprop:Generator_ColumnPropNameInRow="OrderMonth" msprop:Generator_ColumnPropNameInTable="OrderMonthColumn" msprop:Generator_UserColumnName="OrderMonth" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="FirstOrderYear" msprop:Generator_ColumnVarNameInTable="columnFirstOrderYear" msprop:Generator_ColumnPropNameInRow="FirstOrderYear" msprop:Generator_ColumnPropNameInTable="FirstOrderYearColumn" msprop:Generator_UserColumnName="FirstOrderYear" type="xs:int" minOccurs="0" />
              <xs:element name="LastOrderYear" msprop:Generator_ColumnVarNameInTable="columnLastOrderYear" msprop:Generator_ColumnPropNameInRow="LastOrderYear" msprop:Generator_ColumnPropNameInTable="LastOrderYearColumn" msprop:Generator_UserColumnName="LastOrderYear" type="xs:int" minOccurs="0" />
              <xs:element name="ProductLine" msprop:Generator_ColumnVarNameInTable="columnProductLine" msprop:Generator_ColumnPropNameInRow="ProductLine" msprop:Generator_ColumnPropNameInTable="ProductLineColumn" msprop:Generator_UserColumnName="ProductLine" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddressLine1" msprop:Generator_ColumnVarNameInTable="columnAddressLine1" msprop:Generator_ColumnPropNameInRow="AddressLine1" msprop:Generator_ColumnPropNameInTable="AddressLine1Column" msprop:Generator_UserColumnName="AddressLine1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddressLine2" msprop:Generator_ColumnVarNameInTable="columnAddressLine2" msprop:Generator_ColumnPropNameInRow="AddressLine2" msprop:Generator_ColumnPropNameInTable="AddressLine2Column" msprop:Generator_UserColumnName="AddressLine2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnnualSales" msprop:Generator_ColumnVarNameInTable="columnAnnualSales" msprop:Generator_ColumnPropNameInRow="AnnualSales" msprop:Generator_ColumnPropNameInTable="AnnualSalesColumn" msprop:Generator_UserColumnName="AnnualSales" type="xs:decimal" minOccurs="0" />
              <xs:element name="BankName" msprop:Generator_ColumnVarNameInTable="columnBankName" msprop:Generator_ColumnPropNameInRow="BankName" msprop:Generator_ColumnPropNameInTable="BankNameColumn" msprop:Generator_UserColumnName="BankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MinPaymentType" msprop:Generator_ColumnVarNameInTable="columnMinPaymentType" msprop:Generator_ColumnPropNameInRow="MinPaymentType" msprop:Generator_ColumnPropNameInTable="MinPaymentTypeColumn" msprop:Generator_UserColumnName="MinPaymentType" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="MinPaymentAmount" msprop:Generator_ColumnVarNameInTable="columnMinPaymentAmount" msprop:Generator_ColumnPropNameInRow="MinPaymentAmount" msprop:Generator_ColumnPropNameInTable="MinPaymentAmountColumn" msprop:Generator_UserColumnName="MinPaymentAmount" type="xs:decimal" minOccurs="0" />
              <xs:element name="AnnualRevenue" msprop:Generator_ColumnVarNameInTable="columnAnnualRevenue" msprop:Generator_ColumnPropNameInRow="AnnualRevenue" msprop:Generator_ColumnPropNameInTable="AnnualRevenueColumn" msprop:Generator_UserColumnName="AnnualRevenue" type="xs:decimal" minOccurs="0" />
              <xs:element name="YearOpened" msprop:Generator_ColumnVarNameInTable="columnYearOpened" msprop:Generator_ColumnPropNameInRow="YearOpened" msprop:Generator_ColumnPropNameInTable="YearOpenedColumn" msprop:Generator_UserColumnName="YearOpened" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DimReseller" />
      <xs:field xpath="mstns:ResellerKey" />
    </xs:unique>
  </xs:element>
</xs:schema>